﻿CREATE TABLE [dbo].[Orders]
(
[OrderID] [int] NOT NULL IDENTITY(1, 1),
[AddedDate] [datetime] NOT NULL,
[AddedBy] [nvarchar] (256) COLLATE Cyrillic_General_Bin NOT NULL,
[StatusID] [int] NOT NULL,
[ShippingMethod] [nvarchar] (256) COLLATE Cyrillic_General_Bin NOT NULL,
[SubTotal] [money] NOT NULL,
[Shipping] [money] NOT NULL,
[ShippingFirstName] [nvarchar] (256) COLLATE Cyrillic_General_Bin NOT NULL,
[ShippingLastName] [nvarchar] (256) COLLATE Cyrillic_General_Bin NOT NULL,
[ShippingStreet] [nvarchar] (256) COLLATE Cyrillic_General_Bin NOT NULL,
[ShippingPostalCode] [nvarchar] (50) COLLATE Cyrillic_General_Bin NOT NULL,
[ShippingCity] [nvarchar] (256) COLLATE Cyrillic_General_Bin NOT NULL,
[ShippingState] [nvarchar] (256) COLLATE Cyrillic_General_Bin NOT NULL,
[ShippingCountry] [nvarchar] (256) COLLATE Cyrillic_General_Bin NOT NULL,
[CustomerEmail] [nvarchar] (256) COLLATE Cyrillic_General_Bin NOT NULL,
[CustomerPhone] [nvarchar] (50) COLLATE Cyrillic_General_Bin NOT NULL,
[CustomerFax] [nvarchar] (50) COLLATE Cyrillic_General_Bin NOT NULL,
[ShippedDate] [datetime] NULL,
[TransactionID] [nvarchar] (256) COLLATE Cyrillic_General_Bin NULL,
[TrackingID] [nvarchar] (256) COLLATE Cyrillic_General_Bin NULL
) ON [PRIMARY]


